Problem Note 45546: Spend values for low-owned products might be incorrect
 |  |  |  |  |
When you view the spend values for low-owned inventory products in the SAS® High Performance Markdown Optimization Client, you might have incorrect values.
This error occurs because the GEO_PROD_OWNED_INV table is not correctly partitioned. The DI_DM.GEO_PROD_OWNED_INV table has the correct data, but the partition level GEO_PROD_OWNED_INV tables are incorrect.
To workaround this issue perform the following steps. All steps need to be performed in a SAS environment with the Merchandise Intelligence libraries allocated.
- Run the macro %di_util_purge_deleted_records(DI_DM.GEO_PROD_OWNED_INV)
- Run the %TKMI_JOB_RO partition_dm_hier_1 task
- On a multi-machine environment run %TKMI_JOB_RO copyDataToCaptains_service
- Run weekly batch optimization
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
A fix for this issue for SAS High-Performance Markdown Optimization 4.3_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/G22.html#45546| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-02-01 13:34:59 |
| Date Created: | 2012-01-31 14:30:21 |